CREATE table "EMPLOYEE_DETAIL" (
    "EMP_ID"             NUMBER NOT NULL,
    "EMP_NAME"           VARCHAR2(4000) NOT NULL,
    "EMP_ADDRESS"        VARCHAR2(4000) NOT NULL,
    "EMP_CONTACT_NUMBER" NUMBER NOT NULL,
    "EMP_DOB"            DATE NOT NULL,
    "EMP_DOJ"            DATE NOT NULL,
    "EMP_DOR"            DATE,
    "EMP_ROLE"      	 VARCHAR2(200) NOT NULL,
    "EMP_USER_NAME"      VARCHAR2(4000) NOT NULL,
    "EMP_PASSWORD"       VARCHAR2(4000) NOT NULL,
    constraint  "EMPLOYEE_DETAIL_PK" primary key ("EMP_ID")
)
/

CREATE sequence "EMPLOYEE_DETAIL_SEQ" 
/

CREATE trigger "BI_EMPLOYEE_DETAIL"  
  before insert on "EMPLOYEE_DETAIL"              
  for each row 
begin  
    select "EMPLOYEE_DETAIL_SEQ".nextval into :NEW.EMP_ID from dual;
end;
/   

